﻿CREATE TABLE [Person]
(
	perid int identity,
	firstname nvarchar(64) not null,
	middlename nvarchar(64) not null,
	sirname nvarchar(64) not null,
	approxHours int not null,
	username nvarchar(32) unique not null,
	password nvarchar(32) not null,
	suffix nvarchar(16) not null,
	homephone nvarchar(16) not null,
	cellphone nvarchar(16) not null,
	address nvarchar(128) not null,
	active smallint default 1,
	manager smallint default 0,
	primary key (perid)
)
